Download data from siebel to access

[dinadvani via AccessMonster.com]

Hello,

I am in preparation of a database and for that I need some help.

The basis idea is to generate some reports based on the source data that will
come from siebel (which is my companies customised software).

Now I don't have any idea as to how I should link the siebel to access so
that I can perform some querries and generate some reports.

I tried Ashish Dev's sample database but I had some problems with it. I am
novice to access and I don't know how to download the InetTransferLib, the
systems give me an error message.

Any help would be appreciated.

Thanks,
D

 

[Steve]

See if Siebel can export to a text file or to Excel. Access can import
either of those.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Hi

Does siebel have an ODBC driver? If so you could use it to create a
Connection String.

BW

 

[dinadvani via AccessMonster.com]

Thanks both of you for replying to my message.

Yes siebel is able to download the data to an excel file. But my client needs
that if he enters the date for the report in access, the database should run
and first go to siebel to pull an updated report and afterwards I will
prepare some queries with which the data will get sorted and different
reports will get prepared.

I don't have an idea whether siebel has an OBDC driver where can I find it?

Once again thanks for your response. I will be awaiting your reply on this,
please reply as I have a call with the client.

Regards,
D

Hi

Does siebel have an ODBC driver? If so you could use it to create a
Connection String.

BW

Hello,

[quoted text clipped - 14 lines]

Thanks,
D

 

[Guest]

Hi

1. An ODBC driver, if available, would be provided by the db's manufacturer.
ODBC drivers provide a common interface enabling different applications to
talk to each other.

2. Are you able to run siebel reports using Command Line commands? If so you
could use VBA's Shell method to launch reports.

3. Perhaps you could persuade your client to migrate to a more 'universal'
database - Access, SQL Server etc !!

Good luck.

BW

Thanks both of you for replying to my message.

Yes siebel is able to download the data to an excel file. But my client needs
that if he enters the date for the report in access, the database should run
and first go to siebel to pull an updated report and afterwards I will
prepare some queries with which the data will get sorted and different
reports will get prepared.

I don't have an idea whether siebel has an OBDC driver where can I find it?

Once again thanks for your response. I will be awaiting your reply on this,
please reply as I have a call with the client.

Regards,
D

Hi

Does siebel have an ODBC driver? If so you could use it to create a
Connection String.

BW

Hello,

[quoted text clipped - 14 lines]

Thanks,
D

 

[Steve]

If Seibel can download data to Excel, it probably has a way to download
selected data. So when the client enters the date for the report in Access,
pass that date via code to Seibel so Seibel downloads only the data related
to that date to a temp Excel file. Then link to the temp Excel file from
Access and prepare the queries you need, sort the data and create your
reports. All this can be done through VBA from the click of a button after
the date is entered.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Thanks both of you for replying to my message.

Yes siebel is able to download the data to an excel file. But my client
needs
that if he enters the date for the report in access, the database should
run
and first go to siebel to pull an updated report and afterwards I will
prepare some queries with which the data will get sorted and different
reports will get prepared.

I don't have an idea whether siebel has an OBDC driver where can I find
it?

Once again thanks for your response. I will be awaiting your reply on
this,
please reply as I have a call with the client.

Regards,
D

Hi

Does siebel have an ODBC driver? If so you could use it to create a
Connection String.

BW

Hello,

[quoted text clipped - 14 lines]

Thanks,
D

 

[dinadvani via AccessMonster.com]

Thanks a lot Steve for your reply.

But as I told in my initial message that I am learning access so this is
looking a bit difficult for me. It would be great If you can suggest some
resources which I can go thru and learn these things.

Thanks,
D

If Seibel can download data to Excel, it probably has a way to download
selected data. So when the client enters the date for the report in Access,
pass that date via code to Seibel so Seibel downloads only the data related
to that date to a temp Excel file. Then link to the temp Excel file from
Access and prepare the queries you need, sort the data and create your
reports. All this can be done through VBA from the click of a button after
the date is entered.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Thanks both of you for replying to my message.

[quoted text clipped - 28 lines]

 

[Guest]

Sorry Steve but your comment that "All this can be done through VBA from the
click of a button after the date is entered" is rather simplistic! Assuming
that Siebel doesn't use VBA and cannot be created as an Object, how could
this be done other than through a Shell Command Line? A Command Line option
is most unlikely to give the functionality need to do what is required.

D - you talk about Siebel but Siebel is just a manufacturer. You need to
find out what drives their applications. I know that Siebel is owned by
Oracle so, perhaps, its Oracle software. If so, then there is a suitable ODBC
driver (it ships as a standard with MS Windows) which would provide the
interface between Access and the Siebel app.

Thanks a lot Steve for your reply.

But as I told in my initial message that I am learning access so this is
looking a bit difficult for me. It would be great If you can suggest some
resources which I can go thru and learn these things.

Thanks,
D

If Seibel can download data to Excel, it probably has a way to download
selected data. So when the client enters the date for the report in Access,
pass that date via code to Seibel so Seibel downloads only the data related
to that date to a temp Excel file. Then link to the temp Excel file from
Access and prepare the queries you need, sort the data and create your
reports. All this can be done through VBA from the click of a button after
the date is entered.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Thanks both of you for replying to my message.

[quoted text clipped - 28 lines]

Thanks,
D

 

[Guest]

Hi D

Addendum to my last message...

According to the Siebel/Oracle website, Siebel apps "integrate seamlessly
with MS Word, Outlook and Excel" If they integrate with Excel they will
integrate with Access as its fundamentally the same application. The
integration will almost certainly be through an ODBC driver which is
"available from the manufacturer".

I think thats your best route - goto www.siebel.com and follow the links to
Support.

Cheers.

BW

Sorry Steve but your comment that "All this can be done through VBA from the
click of a button after the date is entered" is rather simplistic! Assuming
that Siebel doesn't use VBA and cannot be created as an Object, how could
this be done other than through a Shell Command Line? A Command Line option
is most unlikely to give the functionality need to do what is required.

D - you talk about Siebel but Siebel is just a manufacturer. You need to
find out what drives their applications. I know that Siebel is owned by
Oracle so, perhaps, its Oracle software. If so, then there is a suitable ODBC
driver (it ships as a standard with MS Windows) which would provide the
interface between Access and the Siebel app.

Thanks a lot Steve for your reply.

But as I told in my initial message that I am learning access so this is
looking a bit difficult for me. It would be great If you can suggest some
resources which I can go thru and learn these things.

Thanks,
D

If Seibel can download data to Excel, it probably has a way to download
selected data. So when the client enters the date for the report in Access,
pass that date via code to Seibel so Seibel downloads only the data related
to that date to a temp Excel file. Then link to the temp Excel file from
Access and prepare the queries you need, sort the data and create your
reports. All this can be done through VBA from the click of a button after
the date is entered.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Thanks both of you for replying to my message.

[quoted text clipped - 28 lines]
Thanks,
D

 

[dinadvani via AccessMonster.com]

Thanks a lot for your help..!!

Hi D

Addendum to my last message...

According to the Siebel/Oracle website, Siebel apps "integrate seamlessly
with MS Word, Outlook and Excel" If they integrate with Excel they will
integrate with Access as its fundamentally the same application. The
integration will almost certainly be through an ODBC driver which is
"available from the manufacturer".

I think thats your best route - goto www.siebel.com and follow the links to
Support.

Cheers.

BW

Sorry Steve but your comment that "All this can be done through VBA from the
click of a button after the date is entered" is rather simplistic! Assuming

[quoted text clipped - 35 lines]