![]() ![]() Unfortunately, SSIS will not work with the 4D database ODBC driver. But you may be able to load this database with your own bespoke tool that works with the ODBC weirdness of 4D. So I am finished.ĭoes "inherited a 4D database" mean it's running or that you have the datafile and structure but can't open it? I have my own tool (unfortunately I cannot share it) that will load the XML exported data directly to the database. If it's running and you have access to the user environment the easy thing to do is simply use 4D's export functions. If you don't have access to the user environment the only option for ODBC would be if it's designed to allow ODBC or if the developer provided some export capability. If you can't run it you won't be able to directly access the datafile. ![]() 4D uses a proprietary datastructure and it changed from version to version. It's not encrypted by default so you can actually read/scavage the data but you can't just build a DDL and pull from it. ODBC is a connection between the running app and some other source. ![]() Your best bet will be to contact the developer and ask for help. If that's not an option get the thing running. If it's really old you can contact 4D to get a copy of archived versions. Depending on which version it is and how it's built (compiled, interpreted, engined) your options vary. The developer can specify the schema that's available through SQL and we frequently limit what's exposed either for security or usability reasons. It sounds like this may be the case here - it would explain why you don't see the total structure. This can also be done with the native 4D structure. I can limit how much of the 4D structure is visible in user mode on a field by field/table by table basis. Usually this is to make the system less confusing to users but it's also a way to enforce data security. #Razorsql cast function downloadSo I could allow you to download all your 'data' while not allowing you to download the internal elements that make the database to work. If you are able to export the data you want that sounds like the thing to do even if it is slow.Open multiple connections to different MongoDB servers #HOW TO RESET RAZORSQL EVALUATION DOWNLOAD# #HOW TO RESET RAZORSQL EVALUATION DOWNLOAD#.#HOW TO RESET RAZORSQL EVALUATION DRIVERS#.#HOW TO RESET RAZORSQL EVALUATION 64 BIT#. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |