Skip to main content
To homepage To homepage

ODBC

Ask questions about using ODBC data sources within TimeXtender

  • 8 Topics
  • 53 Replies
8 Topics
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 ColumnsBut 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

407
J
Starter
1 month ago
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.

312
Christian Hauggaard
Community Manager
6 months ago
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.

1409
Christian Hauggaard
Community Manager
1 year ago
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 advanceFEN

1416
F
Explorer
1 year ago
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.

18212
vw-victa
Contributor
1 year ago
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  

26013
Thomas Lind
Community Manager
1 year ago
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.  

762
Christian Hauggaard
Community Manager
1 year ago
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?

1022
A
Starter
3 years ago

Badge winners

  • Certified Solutions Architect
    Dikshahas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    brett.taylorhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    RobvdBrinkhas earned the badge Certified Solutions Architect
  • Ingest Expert
    aftabphas earned the badge Ingest Expert
  • Certified Solutions Architect
    Leo Rogemanhas earned the badge Certified Solutions Architect
Show all badges
Terms and ConditionsCookie settings