SmartsIntegrator Support and Discussion Forums

Forum Topics > General Pre-sales Support > Database configuration difficulties > Post a Reply to this Thread

Database configuration difficulties

Share/Bookmark: Add this Thread to Digg Digg   Add this Thread to StumbleUpon Stumble Upon   Add this Thread to Del.icio.us Del.icio.us   Add this Thread to Reddit Reddit   Add this Thread to Facebook Facebook
RE: Database configuration difficulties
by benj on Wed, Jul 2 2008 5:54 PM
Hi G

Whilst you could certainly achieve this ultimately with SmartsIntegrator, I think you're approaching it in the wrong way. There may be an ETL tool out there better suited to your needs (have you looked at SQLServer Integration Services?)

With SmartsIntegrator, the database you create is for your SmartsIntegrator solution. If you want to read data from another database, you can then create a Receive Port with Database transport to read the data in Xml format. You can then process it via a Workflow, and write it out again to a Send port using Database transport. Let me know if you want to give this a go, and I'll be happy to help - I could do with a concrete example of the kind of rules and database format you are trying to achieve though. Of course for client-side processing your client will need SmartsIntegrator installed locally (or you could license it as part of your app).

Let me know how I can help further.

Thanks,

Ben.
Ben Jackson
SmartsIntegrator Technical Support
Quote This Reply
benj
benj
Joined: Thu, Feb 7 2008
Posts: 96
RE: Database configuration difficulties
by portedquery on Wed, Jul 2 2008 5:51 PM
Hi Ben,
I must say thank you very much for your reply!
At the moment I'm looking a several EBS programs in order to do the
following:

The idea is to be able to transfer data (with different data types) from
one Database to another. The data would be insert, update, or delete by
a client. The client has a front end application to make the changes,
but, before any changes are made to the client DB, the data must pass
certain criteria (Rules). Once it pass those rules, will be send to
another remote server to also pass some Rules. Once everything is OK,
the data in question will be, insert, update or delete in the clients
DB. That should be the task, I still do not know if Smart Integrator can
do that.

I did manage to create the first step when I created
the SmartsIntegratorDatabase (so the DB is OK) in the first Database
from where I manage the application.

I presume I need to create two Servers containing the MSSQL servers with
some databases. There is where I fail.
I could not create the connection to those databases, even I did to the
MSSQL, but the user or/and password where not correct... strange because
I manage to connect while creating the SmartsIntegratorDatabase.

A db connection needs

Host
DB name
username
password

The tasks that I have to do are relatively simple, I visualize it in the
following steps, please correct me if I'm wrong since I do not know the
application very well.

1. Create the application DB (SmartsIntegratorDatabase). Done
2. Create first "Server" the connection to one of database.
3. Create a second connection to the remote second DB
4. Start to create the transactions and rules (I do not even try that,
or even know if will be possible).

I'm press for time, and I need to recommend some solution. Even if with
a simple example. Two databases, that can transfer data to each other,
and apply some rule, for example.

I will appreciate your help. Thank you again.
Regards
G
Quote This Reply
portedquery
Joined: Wed, Jul 2 2008
Posts: 72
RE: Database configuration difficulties
by benj on Wed, Jul 2 2008 2:41 PM
Last Edit: Wed, Jul 2 2008 5:52 PM
Hi G

I'm very sorry that you've encountered an issue configuring SmartsIntegrator. I must say that I had thought it was reasonably straightforward, but we're very happy to consider any suggestions you may have in making it easier to follow and improving our terminology.

I'll be very happy to assist you in getting up and running.

It should really just be a case of completing the Server field with the name or IP address of your database server when prompted with the form shown at http://www.smartsintegrator.com/Step1-1.png. If Windows authentication isn't configured then you'll need to enter a username and password as well. It should default to creating a new database for you. On any other machine you just need to check 'Connect' rather than 'Create'.

You say that you created SmartsIntegratorDatabase successfully, but cannot connect to any other database. Could you please clarify what database you have created, and what databases you are trying to connect to. If you could give an overview of your architecture - how many instances of SmartsIntegrator are you installing, what version of SQLServer you are running, what is the network name of the machine on which this runs called, and generally what you are trying to achieve and what problems are you facing. It may also be useful to send some screenshots.

Again, I'm sorry that you've had a problem configuring SmartsIntegrator, and please be assured I will do everything I can to get you up and running shortly.

Thanks,

Ben.
Ben Jackson
SmartsIntegrator Technical Support
Quote This Reply
benj
benj
Joined: Thu, Feb 7 2008
Posts: 96
Database configuration difficulties
by portedquery on Wed, Jul 2 2008 2:29 PM
Last Edit: Wed, Jul 2 2008 5:52 PM
Dear Sir Madam,

After trying for 3 hours to configure Smart Integrator I could not connect to any DB, I use two separate MSSQL servers, but no luck. I'm missing something?

I created on one the SmartIntegratorDatabase, but no luck on connection to any other Database. The names are obscure, host is call Machine name.. Server? is what the DB? The documentation is rudder obscure or incomplete, petty...the price is OK. I will try BizTalk maybe I have better luck.

Have a nice day,

G
Quote This Reply
portedquery
Joined: Wed, Jul 2 2008
Posts: 72
Page 1 of 1