Skip to main content
To homepage To homepage

ODBC

Ask questions about using ODBC data sources within TimeXtender

  • 8 Topics
  • 54 Replies
8 Topics
G
Visitor
gislihbVisitor
asked in ODBC
Connect to MongoDB

I'm trying to connect to MongoDB and load data into Timextender I have a ODBC driver setup, and test connection works. In Timextender I have ODBC Generic Data setup, and test connection works and to Synchronize Data Source works as well. But when I try to execute the data transfer from MongoDB into Timextender then I get an error.

983
peter.jensen
TimeXtender Xpert
J
Starter
j.burgstallerStarter
asked in ODBC
Select Columns for ODBC

Hello, we would like to select the columns what are loaded from a data source to odx with a odbc connector. We tried it this way Click on datasource → Select Tables → Select Columns But there are not columns what we can select from: How is it possible to select columns for data sources using the odbc connector? Thank you and best regards, Julia

507
J
Starter
P
Visitor
panilVisitor
asked in ODBC
ENUM Data type now showing

When attempting to connect to the MySQL database using the ODBC Connector, we are encountering an issue where ENUM data type fields are not displaying. However, when manually inserting the field headers into the query, the values are visible.

402
Christian Hauggaard
Community Manager
I
Starter
info.tejavardhanStarter
asked in ODBC
Is TimeXtender tool is capable to support "MultiSubnetFailover=True" for version 20.39.10.64

Hi Team, we are using sql server 2019 databases and servers are configured with HADR cluster and Always ON (AG) with multi-subnet failover option .The MultiSubnetFailover option in database connection string controls how the client attempts to connect to a database server, especially when multiple IPs are configured. To support AG listener alias connection string with multiple IPs, we need to add additional parameter: “ MultiSubnetFailover=True ” in DB connection string.We need to know TimeXtender 20.39.10.64 tool is capable to support "MultiSubnetFailover=True" parameter in DB configuration or not.

1609
Christian Hauggaard
Community Manager
F
Explorer
FENExplorer
asked in ODBC
How to manage a new field in the staging area without loosing Data through Deployment

Hello, i have the following issue: i would like to save my tables in the staging area so i can store them (because some of my data in the datasource will be deleted soon).Futhermore in the future maybe new fields will be added to those tables in the datasource and then i would be forced to deploy my tables in the staging area. Question : is there a way to keep the old values from that tables and only add the new field to that table without truncating everything with the deployment in the staging area? ty in advance FEN

1536
F
Explorer
vw-victa
Contributor
vw-victaContributor
asked in ODBC
Additional connection properties - new TX version(s)

Hello, for one of our customers we are using the “Odbc Data Provider” so that we can a local ODBC with a specific driver called "Progress OpendeEdge” (Source: ProFashionALL). We need to add Additional Connection Properties for this datasource. In the older TX versions (< v20) we could add these Additional Properties. This is missing in the new TX version so we can't connect to this source at the moment. This is the main source and crucial in this project. Anyone ran into this issue or has a workaround? There is a workaround but this must done at the source where they store the credentials in the “_user table". I hoped there would be a solution at our (TX) side. Hope to hear.

19612
vw-victa
Contributor
P
Explorer
petscheExplorer
asked in ODBC
Configuration of Netsuite provided odbc connector

Hi to all, In order to improve performance of data loading from Netsuite , we were advised to use Netsuite ODBC provided connetor and use Suiteanalytics. I have download the odbc connector provided by Netsuite, and installed it on the Timextender VM, i get an succesful connection in connecting to NS, using ODBC-test connection. However i cannot acess the odbc driver in Timextender ODX, so how do i do that. Keeping in mind that the Netsuite CData connector uses Rest-calls with limits 1000 records.. so that is not feasable. thank you in advance Peter

29613
Thomas Lind
Community Manager
A
Starter
a.rijkensStarter
asked in ODBC
Use of ODBC

Hello, one of our customers is considering the use of TimeXtender but their IT department is not supporting ODBC. Is it possible to discover (metadata analysis) and transfer data from new datasources (SQL, Oracle, etc.) without the use of ODBC? Or can all be done using the ODX server?

1112
A
Starter

Most helpful members this week

Badge winners

  • Innovator
    Bernarddbhas earned the badge Innovator
  • Certified Solutions Architect
    JeroenStahas earned the badge Certified Solutions Architect
  • Ingest Expert
    nmohas earned the badge Ingest Expert
  • Ingest Expert
    oscarclevehas earned the badge Ingest Expert
  • Ingest Expert
    fwagnerhas earned the badge Ingest Expert
Show all badges

Popular tags

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings