Community
Showing results for 
Search instead for 
Do you mean 
Reply

Exporting or share data with another DB in another format than .ADF

Accepted Solution Solved
Copper Contributor
Posts: 26
Country: Canada
Accepted Solution

Exporting or share data with another DB in another format than .ADF

Hi, 

 

How do we export or share data with another server (Not act! server) 

 

The town hall need to acces data from my Act! DB ?

 

They ask me to get a .sql or any other readable format.

 

Anyone have suggestion on how to proceed?

 

Tried to export with windows sql server import export wizard but got error ..

 

 

Thank you

 

Act! Premium Version 18.2.53.0, Update 4


Accepted Solutions
Solution
Accepted by topic author olivier.fortin
‎01-04-2017 04:46 AM
Bronze Elite Contributor
Posts: 1,425
Country: United_Kingdom

Re: Exporting or share data with another DB in another format than .ADF

It rather depends on what data your want to share and if it is 1 way (Out of ACT) or 2 way.

 

You can use Excel for Contact table information but not notes or history etc.

 

SQL export takes some knowledge and access to SQL SA password.

 

ACT Does have an OLEDB to allow access ACT and here is a link about it.

 

http://kb.act.com/app/answers/detail/a_id/25186/~/how-to-create-an-ole-db-2.0-connection-in-act!

 

There are also add-ons that would allow data export.

 

Lastly - I do have a data exchange Guru on the team who specialises in 2 way data exchange with ACT and 3rd party programs but as they are bespoke solutions it will normally take between 5 and 10 man days to create.

 

 

View solution in original post


All Replies
Solution
Accepted by topic author olivier.fortin
‎01-04-2017 04:46 AM
Bronze Elite Contributor
Posts: 1,425
Country: United_Kingdom

Re: Exporting or share data with another DB in another format than .ADF

It rather depends on what data your want to share and if it is 1 way (Out of ACT) or 2 way.

 

You can use Excel for Contact table information but not notes or history etc.

 

SQL export takes some knowledge and access to SQL SA password.

 

ACT Does have an OLEDB to allow access ACT and here is a link about it.

 

http://kb.act.com/app/answers/detail/a_id/25186/~/how-to-create-an-ole-db-2.0-connection-in-act!

 

There are also add-ons that would allow data export.

 

Lastly - I do have a data exchange Guru on the team who specialises in 2 way data exchange with ACT and 3rd party programs but as they are bespoke solutions it will normally take between 5 and 10 man days to create.

 

 

Copper Contributor
Posts: 26
Country: Canada

Re: Exporting or share data with another DB in another format than .ADF

Thank you,

Copper Contributor
Posts: 26
Country: Canada

Re: Exporting or share data with another DB in another format than .ADF

When i run actdiag i dont have 

  • ACT! OLE DB Provider for Reporting 2.0

Lookinbg for download them but dont find anything..

Bronze Elite Contributor
Posts: 1,425
Country: United_Kingdom

Re: Exporting or share data with another DB in another format than .ADF

Have you done the following in ACTDIAG ?

 

Select Databases - Database List

 

Right Click over database

 

Database Rebuild - Rebuild OLEDB Report Objects

Copper Contributor
Posts: 26
Country: Canada

Re: Exporting or share data with another DB in another format than .ADF

[ Edited ]

Just made the rebuild.

 

I dont see it in my database setting

 

I'm using microsfot sql server 2014

 

Sans titre.jpg

Bronze Elite Contributor
Posts: 1,425
Country: United_Kingdom

Re: Exporting or share data with another DB in another format than .ADF

Not sure why you are looking in there

 

ACTDIAG allow you to rebuild the OLEDB and also see the Internal Field names for ACT as seen by the OLEDB reader

 

To see the internal field names go to Database - Database List 

 

Right Click and Select Reports - Click the Field Detail Report and OK

 

 

 

 

Copper Contributor
Posts: 26
Country: Canada

Re: Exporting or share data with another DB in another format than .ADF

i want to enable the OLEDB to make a connection to my database.
Bronze Elite Contributor
Posts: 1,425
Country: United_Kingdom

Re: Exporting or share data with another DB in another format than .ADF

In the link I provided have you tried the section 

 

Connecting using the ACT! OLE DB Provider 2.0

Copper Contributor
Posts: 26
Country: Canada

Re: Exporting or share data with another DB in another format than .ADF

[ Edited ]

I'm confuse about this process...

 

I dont know if i have  ACT! OLE DB Provider for Reporting 2.0

 

I use Act Premium v18

 

The data i need to export is  located in custom table

 

I want to made 1 way connection from Me (Water treatement plan) to Town hall