Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

We use ODBC currently to do this but quite laborious . We ar...


Ian Dalton

Recommended Posts

Hi Dan! Welcome the fabulous world of myibi:)

Starting in 7703 (I think) we started offering an adapter to read XLSX files directly.

You might take a look at this PDF, Chapter 16 to see if its helpful:

8105m Adapter Administration Manual

Chapter 16 - Using the Adapter for Excel (via Direct Retrieval)

Page 677

Managing Metadata for Excel (via Direct Retrieval) / Procedure: How to Create a Synonym

Hopefully that helps. Im assuming you want to leave the file as an xlsx - you could always use the Upload Data idea to actually move a copy of the file up to the reporting server and WF will automatically create a new master for you. Be aware when you do this, the file is not really still an XLSX file - it gets converted during the upload phase to a normal flat file. But the upload Data option is easy to do.

Either way, its handy to use the DATASET= paremeter in your master/acx to locate the file to be read instead of always having to do a FILEDEF to point to the file.

If you run into problems, let us know.

Thanks!

Toby

Link to comment
Share on other sites

Hi Chuck, thanks for the welcome. I realize that regardless of adapter you need to create the metadata but with ODBC it is quite fiddly to ensure all the fields are in the correct format plus making sure that the data you wish to use is named correctly. It works fine but I think the Data Retrieval approach would be simpler and I believe you have to pay for this adapter (which we havent as yet !).
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...