ETLS - ETL for SuiteCRM

by infospectrum

An ETL tool that works with all editions offering fast data uploads using the latest API methods. Designed to synchronize your existing applications data with both standard and custom modules. Imports cloud-based data into your instances and pulls data from your SuiteCRM for local reporting.

Free 30 day trial
Try it Now

#151 - DSN under windows 10

Closed Installation created by y9zze9ccmy0wbtwqe4 7 years ago

Hi, I need to connect a local informix database (via ODBC) to my remote mysql server (where suiteCrm is hosted). In windows 10 the ODBC configuration is stored in the registry, not in a DSN file. Therefore I can't use my ODBC connection.

Please cancel my free trial.

Thanks

  1. infospectrum member avatar

    infospectrum Provider

    7 years ago

    Greetings,

    You can cancel your free trial through SugarOutfitters at any time. We have provided support for other ETLS users under Windows 10, and here is a quick reference regarding the use of DSN: https://technet.microsoft.com/en-us/library/hh771015.aspx.

    Thank you for you interest in ETLS.

  2. y9zze9ccmy0wbtwqe4 member avatar

    y9zze9ccmy0wbtwqe4

    7 years ago

    Hi, thanks for your messages. My ODBC driver works fine with other software, it's just that I can't figure how to use it with ETLS. ETLS is asking me to load a file in the "Data Source" field. How can I do that with windows 10 where DSN information is stored in the registry and not in files ? Thanks for your help

    Thierry

  3. infospectrum member avatar

    infospectrum Provider

    7 years ago

    Greetings,

    Here are the steps do setup a file DSN in Windows 10 for use in ETLS:

    1. Click on Windows Start and type ODBC
    2. Click on ODBC Data Sources
    3. Select the File DSN tab
    4. Click "Add..." button
    5. Select the driver under 'Create New Data Source' and click 'Next >'
    6. Click 'Browse..' to point to the ETLS installation directory and type the DSN file name to be saved. 7, Use the DSN file name created in 6 above when ETLS ask load a file in the "Data Source" field.

    Hope this helps and thanks again for your interest in ETLS.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • Supported Versions
  • 7.0.0 to 8.6.1

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

The simplest way to work™. Glances integrates SuiteCRM with all your favorite workplace apps, acting as your go-to hub for real-time customer insights and personal tasks.

Featured

QuickEditS

Enhanced editing of SuiteCRM module records. Work seamlessly across all SuiteCRM editions using a spreadsheet-like interface. Browse and export or import your data quickly and easily.

Find and Replace

The Find and Replace extension enables you to find a specific word and replace it with a different word all from the list view. Run the replace against one record or as many as you would like. No longer do you need to slowly go from record to record to make wholesale changes.
Integrations Productivity Reporting