Microsoft SQL connectivity

82 views
Skip to first unread message

ek...@rrms.com

unread,
Oct 25, 2021, 11:11:26 AM10/25/21
to jBASE
I am attempting to connect Microsoft's SSIS versions 15.0.2000.68 (VS 2017) or 15.0.2000.123 (on VS2019)  to jBASE 5.8.4 to pull the jBASE information over to a Microsoft data warehouse.. is there a good way to do this? It doesn't have to be SSIS, most any ETL program will work to get the data from jBASE to MSSQL.

Thanks

Dick Thiot

unread,
Oct 25, 2021, 6:06:38 PM10/25/21
to jb...@googlegroups.com
There is a brand new product on the market called MVsync (https://prosolgrp.com/mvsync/).  This product has many advantages over traditional products to synchronize data to SQL server.  Using MVsync, you can then access your MultiValue data using relational tools using your MultiValue dictionaries to create the definitions.  MVsync can also be used for bidirectional synchronization if desired.  This is a real-time synchronization of the data.  Maverick Systems is a reseller in the U.S. for this product as well as MVsharp, MVrest and MVpro.  These tools all have the advantage of handling data in your MultiValue data that does not conform strictly to data type rules required by Microsoft SQL and other relational databases.

Demonstrations are available.  You can reach us at info AT maverick DOT systems.  We would love to show you



On Mon, Oct 25, 2021 at 10:11 AM ek...@rrms.com <ek...@rrms.com> wrote:
I am attempting to connect Microsoft's SSIS versions 15.0.2000.68 (VS 2017) or 15.0.2000.123 (on VS2019)  to jBASE 5.8.4 to pull the jBASE information over to a Microsoft data warehouse.. is there a good way to do this? It doesn't have to be SSIS, most any ETL program will work to get the data from jBASE to MSSQL.

Thanks

--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

---
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/74d09ef7-8672-4d75-a85e-4a0270a67080n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages