Upload Excel sheet using Data Integrator 6.1?

[Former Member]

hi all ,

Upload Excel sheet using Data Integrator? and how to create ODBC for the PC and jobserver i am using version 6.1? i am using excel as my one of the data source and tell me how to use different types of data sources in DI . after uploading the xl file if i apply any transform on the excel data i will give error like

Posted: 25 Sep 2008 04:30

Post subject: Re: Upload Excel sheet using Data Integrator?

-

---

I am getting the error like

3128 292 CON-120302 09-25-08 09:59:40 ODBC call <SQLDriverConnect> for data source <sas> failed: <[Microsoft][ODBC Driver Manager] Data source name not found and no

3128 292 CON-120302 09-25-08 09:59:40 default driver specified>. Notify Customer Support.

1512 2992 CON-120302 09-25-08 09:59:41 ODBC call <SQLDriverConnect> for data source <sas> failed: <[Microsoft][ODBC Driver Manager] Data source name not found and no

1512 2992 CON-120302 09-25-08 09:59:41 default driver specified>. Notify Customer Support.

Please help me out

Thank u

[scott_broadway]

Hi Shonti,

The 11.5 and 11.7 versions of DI offer a more native interface to Excel spreadsheets by using the new Excel Adapter. Additionally, DI 6.1 is no longer supported in any way.

Thanks,

~Scott

[Former Member]

Thank u Scott , can i upgrade my DI 6.1 to 11.7 without affecting my projects.

[scott_broadway]

Hi Shonti,

The DI 11.7 installer can be used to upgrade a DI 6.1 local repository (e.g. the upgrade is supported). This will migrate all jobs and flows. They will remain intact, however, this is always a major migration effort and should not be taken lightly. If you do upgrade, please make sure this is a planned effort with rigorous testing and validation. You should also ensure that you consult the release notes and [supported platforms documentation|https://websmp110.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000712240&_SCENARIO=01100035870000000202] for the 11.7 package you intend to install. The DI 11.7 documentation also contains info about how to install and configure the Excel Adapter, and what functionality it provides.

Thanks,

~Scott

[Former Member]

We are getting the same error quite often when our data integrator product is trying to connect to sql servers.... We are on version 11.7.3.4. Is this because of the sql server side or data integrator?